Setting Index Properties

Use the Index Name edit box to set the index name. No schema name can be included here; the index is always created in the same schema as its parent table.

To include field(s) in the index, just simply double-click the Field(s) Name field or click to open the editor for editing. The Order(s) dropdown list is used to set sort direction.

Note: Some of data types do not allow indexing. For example: text

The Index Type dropdown list defines the type of the table index.

Clustered
Create an index in which the logical order of the key values determines the physical order of the corresponding rows in a table.

Nonclustered
Create an index that specifies the logical ordering of a table. With a nonclustered index, the physical order of the data rows is independent of their indexed order.

Spatial
Create a spatial index on a specified table and column. An index can be created before there is data in the table.

Note: Support from SQL Server 2008 or later and SQL Azure.

XML
Create an XML index on a specified table. An index can be created before there is data in the table.

Note: Support from SQL Server 2005 or later.

Unique
Create a unique index on a table.

Comment
Specify the comment of the index.

Note: SQL Azure does not support.